﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace Employees
{
    public class NorthWind
    {
        private static NortWindDataContext context = new NortWindDataContext();

        public static List<Order> GetOrdersForEmployee(int employeeId)
        {
            var orders = from order in context.Orders
                         where order.EmployeeID == employeeId
                         select order;
            return orders.ToList();
        }
    }
}